AVERAGEIF

Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.

Syntax

expression.AVERAGEIF(arg1, arg2, arg3);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange	ApiName
arg2	Required	ApiRange	ApiName	number
arg3	Required	ApiRange	ApiName

Returns

number

Example

var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var numbers = [67, 87, 98, 45];

for (var i = 0; i < numbers.length; i++) {
    oWorksheet.GetRange("A" + (i + 1)).SetValue(numbers[i]);
}

var oRange = oWorksheet.GetRange("A1:A4");
oWorksheet.GetRange("C1").SetValue(oFunction.AVERAGEIF(oRange, ">45"));